package com.grad.why.studentsystem.service;

import com.grad.why.studentsystem.domain.ChooseCourse;
import com.grad.why.studentsystem.domain.Student;
import com.grad.why.studentsystem.domain.current.CurrentChooseCourseInfo;

import java.util.List;

public interface ChooseCourseService {
    List<CurrentChooseCourseInfo> getChooseCourseInfos(int offset, int limit, String search);

    long getChooseCourseInfosLength(String search);

    int deleteChooseCourseInfoById(int i);

    List<CurrentChooseCourseInfo> getAllChooseCourseInfos();

    int getMaxChooseCourseId();

    int insertEntity(ChooseCourse chooseCourse);

    int getCountOfStudentName(String stuName);

    int getStudentIdByStudentName(String stuName);

    int updateChooseCourseInfoByEntity(ChooseCourse chooseCourse);

    int checkStudentIsExist(int studentId);

    List<Student> getStudentByCourseId(Integer cid);

    int isExistChooseCourseInfo(ChooseCourse chooseCourse);

    List<ChooseCourse> getChooseCourseByCid(Integer courseid);

    int addStudentInfosByExcelFile(String uploadCurrentFileName);

    List<ChooseCourse> getChooseCoursesBySid(int sid);
}
